UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Drheia8c9A6IRgfrPVhuYvcjYFtYCAYGd0tgzSDthRQ='
WHERE
key_id = '781b4f7fbce41e059c37df98619019b24cdb1e5f5475b4852f0137be15ab8944'
AND (
token = 'Drheia8c9A6IRgfrPVhuYvcjYFtYCAYGd0tgzSDthRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)