UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8XQBRd2v7+YOwB1fOrIYnduKOkA3gscIJnPHlssMP0='
WHERE
key_id = 'e1aba00ed4c737c8e7f6a9531668ac74899e5d83c63107c7af63e70fc2796dc1'
AND (
token = 'n8XQBRd2v7+YOwB1fOrIYnduKOkA3gscIJnPHlssMP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)