UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LLVYgiBUPK8D2hZqlFfUBKW0PV4ows2eGH8k+xxBDRc='
WHERE
key_id = '45793c537f982d65ad63c7ec0002a4a199de4ed3258fabac8c407ef77a5559cb'
AND (
token = 'LLVYgiBUPK8D2hZqlFfUBKW0PV4ows2eGH8k+xxBDRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)