UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LtYY16THAyHBwi+mxcs/XbxzF3Fqo8etZ5J1tJ4RRtI='
WHERE
key_id = '8e99df9158259285befb6530ed49a06d337a676e337077b02a66a3dc8ca57731'
AND (
token = 'LtYY16THAyHBwi+mxcs/XbxzF3Fqo8etZ5J1tJ4RRtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)