SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '04644d63fe5c3c5836fe1033e8b7aec2b31b06458bd933d3928e099f8e959d20' 
  AND token = 'OUlw+WeigqgkBq3T7Rr+e23+Vjc2uslI0kgYR7qqeMc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00016

JSON explain

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