UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8G1nlm++X5mgKW4qz29wNPQi8gWW7yYQrWeJAVbbKr4='
WHERE
key_id = 'a08ef13d770370d901b658b31929ade6f36766a2f5cb90e23f4d1e4ee95bd754'
AND (
token = '8G1nlm++X5mgKW4qz29wNPQi8gWW7yYQrWeJAVbbKr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)