UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6xcZMl0ByGhRlc/4nLT2aJakkE73EdfsHKr1/q5MRg='
WHERE
key_id = '2d77815c84e08637f09a00812825198c935d23cc536c58272fce879c168c9340'
AND (
token = 'x6xcZMl0ByGhRlc/4nLT2aJakkE73EdfsHKr1/q5MRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)