SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e41c0d09b8084af2572e0767c8d13138b647c551e20edd5ad6c703424e9291d0' 
  AND token = 'w8PntGuH++VmTD/exEeZ2Nm6tQpybLDT3VJpz76zTrA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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