UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PdCbFCmjwhmxVKJ/W3eDPI/jWyoZlUxhUHMjF600d8M='
WHERE
key_id = 'e7543e78461036742c6f9759050f7ebbe5d9802f2f8b4ab78f63179de2e44abd'
AND (
token = 'PdCbFCmjwhmxVKJ/W3eDPI/jWyoZlUxhUHMjF600d8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)