SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '205c2c1173a4e212e186d2fc0331e2cff20f07f3ee3e16c7e52346416a03740a' 
  AND token = 'K9qe5VGS74g5RdRHUwFtIMpXIdL5n8LAiaK6CC+b5BQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00014

JSON explain

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