UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOUeiojs5c3Uz5Rs12NCnMXIZRnJEAO84U5R4WK2CXM='
WHERE
key_id = 'eafab9c4430c5dbcd5b373bf8686798592d3c26d6f2b8d7734057c1e12936d78'
AND (
token = 'sOUeiojs5c3Uz5Rs12NCnMXIZRnJEAO84U5R4WK2CXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)