SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '07ae28c1031ce526118a28bae2c3d816ff9b99fd1e08d4a9d5373c7dbee6ad4f' 
  AND token = 'eJa8Zjneuu/rspfFJk3X2GcLtei9DhU4S8HvkmQv/1U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}