UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPQFMyq6JhOaYSUeMR/bjI9vle7QTVkI7PitbvDifn8='
WHERE
key_id = '7a4e81f7c68e110ad8754bbf9f692e9bd8350201b1edaf54e6a887c8d26e1f5f'
AND (
token = 'HPQFMyq6JhOaYSUeMR/bjI9vle7QTVkI7PitbvDifn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)