UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPph0nL8wSWhEm/b4BtzbpPNw0g9k51yWZGYIzrw8jQ='
WHERE
key_id = '536492862ab240a363d2e4f2fb0339bbc90ec2574a0e1da3ffa048b4ce4debe4'
AND (
token = 'bPph0nL8wSWhEm/b4BtzbpPNw0g9k51yWZGYIzrw8jQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)