SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'caa9a62a8163e52f6447d90d77d0cd7f3998a920ef3c6c066905c04515c17c37' 
  AND token = 'tjjmup7KC1VXLtGik/9E2DabrHHQOi64NGT9wmD4qJ0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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