UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'a1rlW0jrwoxM6ZIK9RY2LGeQl0Gf5N4tGT7bhDz2g7Y=' 
WHERE 
  key_id = '9a275e3213cb159c5b766a74f306f02fc0b8a91c70417d45fe4437c6221d3378' 
  AND (
    token = 'a1rlW0jrwoxM6ZIK9RY2LGeQl0Gf5N4tGT7bhDz2g7Y=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039