UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MvNKV7ksYfdLQ9goXSl7InOaIgAfRFWAJjCzUjDlpvU='
WHERE
key_id = '17a4d5b484c1067d9f69772692ceee7667c52a5af2625933caff5a9520a40617'
AND (
token = 'MvNKV7ksYfdLQ9goXSl7InOaIgAfRFWAJjCzUjDlpvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)