UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1gkkpPGI3No3wS4u3jd4rKDPMTrpM5vHPuXK9qctycQ=' 
WHERE 
  key_id = '7f21d5aafec73e45c27c24699fa4d81c37aa0c80c6d9d7a7cdc6c53da8ca4db1' 
  AND (
    token = '1gkkpPGI3No3wS4u3jd4rKDPMTrpM5vHPuXK9qctycQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025