UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x0fVdB2e0Q4EEhNLB36wMJA9g0xeJWNG+Pm67wtVYJE='
WHERE
key_id = 'd817d0f57b8ec084826f5250d09391ff7f99797fc3ffcca4fa935560716c09a5'
AND (
token = 'x0fVdB2e0Q4EEhNLB36wMJA9g0xeJWNG+Pm67wtVYJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)