SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '58ac3ae7bfcd8ea5245e48818d8055e2e1a7093a7ef4fd941bd1324a8b4de1fa' 
  AND token = 'J8t7ZiOsLiKL29DAouKypgYvsCXqkE4YZfV3mbp5oW0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00049

JSON explain

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