UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'olPbfjRjAo7HeNpguquXJ/S0pB6GdHalyFeXIRspBHA='
WHERE
key_id = 'bcc2565940a420968c3628515889283b8c8b7bc9d6d23e6b6bde9204ddec2960'
AND (
token = 'olPbfjRjAo7HeNpguquXJ/S0pB6GdHalyFeXIRspBHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)