UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LRsOfybanIISqP0U7J7I3y9jKiJwMHvl0G8dKY3Wlw='
WHERE
key_id = 'd3a2b199f58256ca8ceeb2a374df7496dd88a67329fc08f1ea95e94e956b592f'
AND (
token = '6LRsOfybanIISqP0U7J7I3y9jKiJwMHvl0G8dKY3Wlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)