UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCe+txrTBw2z6KmSWWIqPrgECy3Pb+GzXP/LEmcWG+0='
WHERE
key_id = 'a9d02bc069031f5228d82d65be2ce29ab58767ae4eef548b49ed45a849dd12fe'
AND (
token = 'cCe+txrTBw2z6KmSWWIqPrgECy3Pb+GzXP/LEmcWG+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)