UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCQr8YieBv1wNMC9mb5DDJVL3RwchWA1PnpFAXmKik0='
WHERE
key_id = '257a9364ba3ee9b2bb4cb0fc4e7c325f339ff8da49131548af326c0a9938d58d'
AND (
token = 'lCQr8YieBv1wNMC9mb5DDJVL3RwchWA1PnpFAXmKik0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)