SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2b3078ba8c90c5dd51f65a0ae1af7c209d2c45cc86491c13f05b15df188a65f9' 
  AND token = 'OHFkJIhoiQl9j2lsC0ASXUyvJ3diKg3nvawN6Ov9X7M=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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