UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UT2QqBvGBSsIDyPGN5k53YzUNS0ZxaL7BKy6XiT2vvw='
WHERE
key_id = '49b8832e4f9c4853d6f42f396fa475090523705e6a8df8ca263e6a5ca147605a'
AND (
token = 'UT2QqBvGBSsIDyPGN5k53YzUNS0ZxaL7BKy6XiT2vvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)