SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'c484e10d17809772dc1a81d69561c6d460a2bd020b4600c5a9eb291e512c458f' 
  AND token = 'aYo8CfG7t3Lb+r7oa7OQOPwuBKeWdVk3L6i2oEH6/xQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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