SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7573d3b1204ceb169f2230b99beb7eaef82d78eb1c8e9c21125d0c8aa9aefde4' 
  AND token = '8GPu6s3vS61W2H9NH3gchiv5Zq4vL6TFHOy2zOFvbgQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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