UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oG/5ILWxojS0vY/2Tk7AcAI976F70xVpxNPzM9Am9M='
WHERE
key_id = 'ad8cb0331f696a0113b6d232a4dbb70c37e12eef09b970df5b157b6bd9ce025c'
AND (
token = '9oG/5ILWxojS0vY/2Tk7AcAI976F70xVpxNPzM9Am9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)