UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jT5PagSLiRvveyPvfEm2xC7bALJoMHC41+2hW4fEmF8='
WHERE
key_id = 'afbb52dfb25c3d5a32d68598cd177ecbc9cb74946b6872de80860401ceba90ae'
AND (
token = 'jT5PagSLiRvveyPvfEm2xC7bALJoMHC41+2hW4fEmF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)