UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XeYQeLQNzEZb71GW7D1Wgw52y+cUIatJsYg7UxAQTu8='
WHERE
key_id = 'a07f8a33f5955106cd75a588d9222bb793d9b81a92c621c16b91390fb52ee7d2'
AND (
token = 'XeYQeLQNzEZb71GW7D1Wgw52y+cUIatJsYg7UxAQTu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)